Invalid SQL syntax - expected token: AS. (Error 3728)

This error occurs when defining or creating a view or procedure through SQL DDL. The error would be generated with the following syntax: CREATE VIEW viewname SELECT�. To avoid the error, change the syntax to the following: CREATE VIEW viewname AS SELECT�.